Tabela MedicalProductDetails

Definicja tabeli MedicalProductDetails

Name

MedicalProductDetails

Code

MedicalProductDetails

Comment

 


Lista kolumn tabeli MedicalProductDetails

Name

Code

MedicalProductDetailsID

MedicalProductDetailsID

MedicalProductDefinitionID

MedicalProductDefinitionID

CatalogueCode

CatalogueCode

StartDT

StartDT

StopDT

StopDT

BaseTariff

BaseTariff

UnitsCount

UnitsCount

Active

Active

IsDictEntry

IsDictEntry


Kolumna MedicalProductDetailsID tabeli MedicalProductDetails

Definicja kolumny MedicalProductDetailsID tabeli MedicalProductDetails

Name

MedicalProductDetailsID

Code

MedicalProductDetailsID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MedicalProductDefinitionID tabeli MedicalProductDetails

Definicja kolumny MedicalProductDefinitionID tabeli MedicalProductDetails

Name

MedicalProductDefinitionID

Code

MedicalProductDefinitionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CatalogueCode tabeli MedicalProductDetails

Definicja kolumny CatalogueCode tabeli MedicalProductDetails

Name

CatalogueCode

Code

CatalogueCode

Data Type

VARCHAR2(2)

Mandatory

No

Comment

kod katalogu swiadczen


Kolumna StartDT tabeli MedicalProductDetails

Definicja kolumny StartDT tabeli MedicalProductDetails

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli MedicalProductDetails

Definicja kolumny StopDT tabeli MedicalProductDetails

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna BaseTariff tabeli MedicalProductDetails

Definicja kolumny BaseTariff tabeli MedicalProductDetails

Name

BaseTariff

Code

BaseTariff

Data Type

NUMBER(10,4)

Mandatory

No

Comment

taryfa bazowa


Kolumna UnitsCount tabeli MedicalProductDetails

Definicja kolumny UnitsCount tabeli MedicalProductDetails

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(10,4)

Mandatory

No

Comment

liczba rozl. jednostek miary zawartych w op.


Kolumna Active tabeli MedicalProductDetails

Definicja kolumny Active tabeli MedicalProductDetails

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IsDictEntry tabeli MedicalProductDetails

Definicja kolumny IsDictEntry tabeli MedicalProductDetails

Name

IsDictEntry

Code

IsDictEntry

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy wpis pochodzi bezposrednio ze slownika PRH?


Lista kluczy tabeli MedicalProductDetails

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli MedicalProductDetails

Definicja klucza Identifier_1 tabeli MedicalProductDetails

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment